package com.guigu.www.mapper;

import com.guigu.www.pojo.Intervention;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author DengHao
 * @since 2021-10-21
 */
public interface InterventionMapper extends BaseMapper<Intervention> {
    /*根据干预方案的id查询干预方案*/
    @Select("SELECT * FROM intervention WHERE inter_id=#{nid} AND inter_state=0")
    Intervention selecthealth(@Param("nid") int nid);

}
